SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweDivisionesaAbrir
AS
SELECT     IdDivision as ID, Reestructura, SubOrganizacion, Descripcion, EsGrupo, Curso, GrupoCarreras, Division, FechaAlta, Baja, FechaBaja, TasaRepitencia, 
                      TasaDesgranamiento, Turno, CondicionDeAgrupamiento, TasaDesercion, IdDivisionOperativa
FROM         dbo.tb_DivisionesAAbrir

GO
GRANT SELECT ON  [dbo].[vweDivisionesaAbrir] TO [Informatica]
GRANT INSERT ON  [dbo].[vweDivisionesaAbrir] TO [Informatica]
GRANT DELETE ON  [dbo].[vweDivisionesaAbrir] TO [Informatica]
GRANT UPDATE ON  [dbo].[vweDivisionesaAbrir] TO [Informatica]
GRANT SELECT ON  [dbo].[vweDivisionesaAbrir] TO [SoloVer]
GO
